﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'proc_cm_ListSermonSeries')
BEGIN
    PRINT 'Dropping Procedure proc_cm_ListSermonSeries'
    DROP  Procedure  proc_cm_ListSermonSeries
END
GO

PRINT 'Creating Procedure proc_cm_ListSermonSeries'
GO

CREATE PROCEDURE [dbo].[proc_cm_ListSermonSeries]
AS
BEGIN
	SET NOCOUNT ON

	SELECT 
		[sermon_series_id]
		,[series_nm]
		,[series_image_url]
		,[detail_txt]
	FROM
		[dbo].[tbl_sermon_series] (NOLOCK)
	ORDER BY 
		[series_nm]
END
GO

GRANT EXEC ON dbo.proc_cm_ListSermonSeries TO PUBLIC
GO

